UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vc4yZPdye54GaQQoj/sH3Sy3nHzOxzYURRIpqmBTIC4='
WHERE
key_id = 'ec6f0b5f5648a167e7bee9cb277c3264074ad8ac73c7e2eb2011178f309c579e'
AND (
token = 'vc4yZPdye54GaQQoj/sH3Sy3nHzOxzYURRIpqmBTIC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)