UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bu7Yg71Szq/FmxPCl0dM3uhB4aWPsp5nmMuRA2sKgJs=' 
WHERE 
  key_id = '82ec92b2e9d7cb091af67463d6e3c13ae978edc874a12a2f8fae8dba2ad58ea7' 
  AND (
    token = 'bu7Yg71Szq/FmxPCl0dM3uhB4aWPsp5nmMuRA2sKgJs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028