UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'JVBQvIsztKN+ecgHPZy/vbYKx+22SPfHdD/YbJ6yKV0=' 
WHERE 
  key_id = '83cd5cb39f41a9fbecc2f9c5c803d3bff8164cf28c638eaa7f06e09759ffa3e5' 
  AND (
    token = 'JVBQvIsztKN+ecgHPZy/vbYKx+22SPfHdD/YbJ6yKV0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00018