UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yGQ1sbTUsBHLcNmR2VuiqJv+D47kMztsDSrlDilds3k='
WHERE
key_id = 'ca0ace4ae012d3a51a6baad4e36ae74970caa37457f6305b3b9028233731f227'
AND (
token = 'yGQ1sbTUsBHLcNmR2VuiqJv+D47kMztsDSrlDilds3k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)