UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a39yHT79hKN7vFV4PLttbnWnDT4GvTc6zceOpxMNcfM='
WHERE
key_id = 'bbb5954366685d3360f19207649a4c990f98d7fe6a4a7fde9e8d6c0d2c6b1ea4'
AND (
token = 'a39yHT79hKN7vFV4PLttbnWnDT4GvTc6zceOpxMNcfM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)