UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1ZuRJsOZagafVk9TB5bdbnR76soxcDvCleCF1RnumGI='
WHERE
key_id = '509369acaf23d811fb7d7bf96064bd9c089381a03d8fc4cdbfd9f71a9d6d8a78'
AND (
token = '1ZuRJsOZagafVk9TB5bdbnR76soxcDvCleCF1RnumGI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)