UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UA7HsZlj9ea9HXDY9DSgEcwW6SL/J1dxDx/YKtrPj8w='
WHERE
key_id = '0da4e96aebf5da771f78d900d55b0b9fc7e71f590c19afe16d9da614c39d5357'
AND (
token = 'UA7HsZlj9ea9HXDY9DSgEcwW6SL/J1dxDx/YKtrPj8w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)