UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NB7If0s18yfoThTFL7QOO3gjB1cTSM01DJ49tJlJwsQ='
WHERE
key_id = '3e85aefb2427ae41ff9af5bd3922c46155a319905a39c3c63025afbb3a081d8a'
AND (
token = 'NB7If0s18yfoThTFL7QOO3gjB1cTSM01DJ49tJlJwsQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)