UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'JNext+7UoEsUxw2R5a1yUNp5x5MckQvl50GcyCDxH6w=' 
WHERE 
  key_id = '39d0c1f20903bc9ef055db84176b2718a41dacacf0537eb2ed77f7b4458cceb3' 
  AND (
    token = 'JNext+7UoEsUxw2R5a1yUNp5x5MckQvl50GcyCDxH6w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031