UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BgAvzW1WfT8dFgQgfA7Nw67LOTj+XthxXxfyBVUbOxM='
WHERE
key_id = '871e34b0ee5ed18f554ee9845e7ba80280959f67b542a11476663cc46702d99d'
AND (
token = 'BgAvzW1WfT8dFgQgfA7Nw67LOTj+XthxXxfyBVUbOxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)