UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'cXnXc2S6zoTJ5KCyzqCHGG5hkkA95RYcwem7i36LQ4E=' 
WHERE 
  key_id = '5bef3c75ae0d866069cf2218c39559de9c70c2a82ed799e053c298115ed6806f' 
  AND (
    token = 'cXnXc2S6zoTJ5KCyzqCHGG5hkkA95RYcwem7i36LQ4E=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00145