UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4qnrPfus6taBLmEpR1YFeZehD0evdo64V+ESJjBFwE4='
WHERE
key_id = 'a49a38a68cc1ec99e746eb60350afe459532000c0ce46aa28d13100865b32280'
AND (
token = '4qnrPfus6taBLmEpR1YFeZehD0evdo64V+ESJjBFwE4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)