UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S48EPqITif/k4pP7ARud1btSAbV8e7xk/0j2mz3+Jp8='
WHERE
key_id = 'c2c7ff7d07e4c62a39527fd963b5946e73c74fbac2fba7c1adff4fa49c16e240'
AND (
token = 'S48EPqITif/k4pP7ARud1btSAbV8e7xk/0j2mz3+Jp8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)