UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NDk3le4zgb825mEQ5jehx7b1nY0zXpgBigwLBhHUQs8='
WHERE
key_id = '1487c47602aaae7389cd708353c4885c8ad1c608158ceed4dc217e3001c92971'
AND (
token = 'NDk3le4zgb825mEQ5jehx7b1nY0zXpgBigwLBhHUQs8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)