UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NcwXgBcyOI4GfOR9S3gQ0W+/dQZ4Nue3w5jbwHRP90A=' 
WHERE 
  key_id = '987d58c48d6780d1f84bb0eb94931879a85d30714f8e8e8d80382ff322cc7857' 
  AND (
    token = 'NcwXgBcyOI4GfOR9S3gQ0W+/dQZ4Nue3w5jbwHRP90A=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024