UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'adNjNJVFNV9Tm28gN1H4CiHkWm+JEI9nIvgpm906Rx4='
WHERE
key_id = 'ac194430b8a741b20e9f411cd6ab1cf81b23bc834781bf1a4f4d02a0e2d84e1f'
AND (
token = 'adNjNJVFNV9Tm28gN1H4CiHkWm+JEI9nIvgpm906Rx4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)