UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'iyQanYi7/xjIeJa8MQ2D14fJIf4MfGdsp3g7UWfkY0s=' 
WHERE 
  key_id = '2d57f86455fe7a966697099ceb1dae7ef90b5cdbf0b9f7a8e686060ec6cd6f65' 
  AND (
    token = 'iyQanYi7/xjIeJa8MQ2D14fJIf4MfGdsp3g7UWfkY0s=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048