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