UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'JHGBjMn4tSX4NYsp8Fwupaq8SMk7jhGowGGRd7J7iIE=' 
WHERE 
  key_id = '7be1a61b84bfe19cf322a781e783cb2e7c5b159c1d8a6bd787faa31d00c444b5' 
  AND (
    token = 'JHGBjMn4tSX4NYsp8Fwupaq8SMk7jhGowGGRd7J7iIE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041