UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KYApbUEs5spANpqV7W50whoFTmUBnwKLi/SuP8Bgb1k='
WHERE
key_id = '5347a7e0e71e526a312012b9b7dd0f083cb30ebc711cf589208b4c74c584166b'
AND (
token = 'KYApbUEs5spANpqV7W50whoFTmUBnwKLi/SuP8Bgb1k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)