UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VNqdNWRIxQA6lnENBHObMrFelE/r8GAB07b747OI/ok='
WHERE
key_id = 'd9f9d48aa096959bac77f6ba49a9032f46375e511bb7c6fb8d307397da190590'
AND (
token = 'VNqdNWRIxQA6lnENBHObMrFelE/r8GAB07b747OI/ok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)