UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'SolAaDz7OKpj4uq8vdF0jOEONSWmv1DcN/89o9VZIZU=' 
WHERE 
  key_id = '2495802578bc5910203e8b929483040c9eb45840cc8f3939d530c24717290934' 
  AND (
    token = 'SolAaDz7OKpj4uq8vdF0jOEONSWmv1DcN/89o9VZIZU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025