UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y5q3qjUWOHv8DaDkDNYetTDTIuh52/aPjA3yHi52Xgw='
WHERE
key_id = '97c7d78d17d24a2bd6d69eb61816b6e184888a4acf9b0515ba55b4da9d0273c3'
AND (
token = 'y5q3qjUWOHv8DaDkDNYetTDTIuh52/aPjA3yHi52Xgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)