UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oA/OJ3QZRX89a84urhjXzl7vdb8zz6yumrO7g/G2oZI='
WHERE
key_id = '00a78393a2c6999fd5166f3dd1bbdff7e65027d231ad7b33129ebd9c6b2bf860'
AND (
token = 'oA/OJ3QZRX89a84urhjXzl7vdb8zz6yumrO7g/G2oZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)