UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z0Zk8kcdARdDsVDx21mJTWhR4w49ctrzOcjEo0DzpIo='
WHERE
key_id = 'bc49a72e81f4fc546bd2d313ce52bb9846fc6c8b3817f7dad38665f10ff90743'
AND (
token = 'Z0Zk8kcdARdDsVDx21mJTWhR4w49ctrzOcjEo0DzpIo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)