UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9g4z7DJQv1eqPBJA58/yqFqNkuG2GAR9SDgB4ecVdE4='
WHERE
key_id = 'f79e2a0998ca8afab883952fc2014b773e9ef92a68385885c16129df09005eef'
AND (
token = '9g4z7DJQv1eqPBJA58/yqFqNkuG2GAR9SDgB4ecVdE4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)