UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'CuLVIlXGeYgKQ5qqT2MH06FJE4n6Uz7DxtWaHes4+CY=' 
WHERE 
  key_id = 'ae0e3e7f2a8eec8a9654c2600bae474c7308948c5863a1257c8f20e53a97e766' 
  AND (
    token = 'CuLVIlXGeYgKQ5qqT2MH06FJE4n6Uz7DxtWaHes4+CY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025