UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'r9Aasptm4nt5DQxxp32lvl0Go9OS4bczCexrA0NfCx0=' 
WHERE 
  key_id = '52d8c37e73509ecf9e601e4658c1928d4636dd09aa337a66361dbd828c713a2a' 
  AND (
    token = 'r9Aasptm4nt5DQxxp32lvl0Go9OS4bczCexrA0NfCx0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033