UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1XygH4ym5e/YmT9dpAg+7E4WqW3pwINMXqUj8phrUY4='
WHERE
key_id = 'e921f4a1a95fb723b42ce1be9744c7c471e8265c3a966566803db5f3960b8ee2'
AND (
token = '1XygH4ym5e/YmT9dpAg+7E4WqW3pwINMXqUj8phrUY4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)