UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/LhZY1bSFPEKXPVm5rtIk0T/srQhTtGIzOgU1uTcFkg='
WHERE
key_id = 'c1de719c9f5417f3015d84cfb377c8882614c877bfa58bb80701681e98cafe3f'
AND (
token = '/LhZY1bSFPEKXPVm5rtIk0T/srQhTtGIzOgU1uTcFkg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)