UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5abvIX+oqPeqKF5sMnNnVhkqSkOpb0UTzqRo11gKMOM='
WHERE
key_id = 'a4df91c2a65cd00edf400e85b58791898c29fc401b5c9401c4f3fdffcf5cf1cf'
AND (
token = '5abvIX+oqPeqKF5sMnNnVhkqSkOpb0UTzqRo11gKMOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)