UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QzQ+aIIEPkPMBoqVbex32ZA/Y3O8emAXc2q/6PfvYh0=' 
WHERE 
  key_id = '20c6d4b03ac299fd349680a8e5eb993c91656c5ebfb8214ca4506c2bcf4a4fdf' 
  AND (
    token = 'QzQ+aIIEPkPMBoqVbex32ZA/Y3O8emAXc2q/6PfvYh0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00019