UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mlnQfxu1l0XrjWvxJHHiZkH3u1S3GlWkNXO/BhosDMw='
WHERE
key_id = '7178ece4db200cd36b91e8e41f17e57630aae4a08f4c71776b6cea03d74d8445'
AND (
token = 'mlnQfxu1l0XrjWvxJHHiZkH3u1S3GlWkNXO/BhosDMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)