UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'w3S56TO0sKaN7cBhPHOjp4Qh4Ch4/7x9IkU9icTxrGo=' 
WHERE 
  key_id = '72e3cad0c48e537aa73b1ba7289d9c0580fad93c886c9b7739e9bebec74fdb65' 
  AND (
    token = 'w3S56TO0sKaN7cBhPHOjp4Qh4Ch4/7x9IkU9icTxrGo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021