UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vXBeGgVZCSUe+81kMONplz/UoLlr1STFJ3LXFajdaaM=' 
WHERE 
  key_id = '122d5986e7066f3e4a08da7dc5ee476ae4eb7c9b9f43e88ca97330514dee9480' 
  AND (
    token = 'vXBeGgVZCSUe+81kMONplz/UoLlr1STFJ3LXFajdaaM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025