UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y+1ujVd2lsgJs6nCGN4MtXAGBCGHxKpW80YfUjSkFu0='
WHERE
key_id = '4e78ec09ce64e9a248fd0000242d645d8970a023be588e291dc8731fe24033cd'
AND (
token = 'y+1ujVd2lsgJs6nCGN4MtXAGBCGHxKpW80YfUjSkFu0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)