UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6gc8Rl9wCDRwkDuEcNIOiqXcZudNdq3588n5cXoxaEw='
WHERE
key_id = 'ed16cede2c1b15a39bab667a3f9243eea30049bbbac208ea5c46fba73a41141a'
AND (
token = '6gc8Rl9wCDRwkDuEcNIOiqXcZudNdq3588n5cXoxaEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)