UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ns5VuqIhG0ioKwlFABE58Yfn5nwoMC3T5jKr8fFPQMw='
WHERE
key_id = '81c391a24c0a665876353ea54ad6764b9c4326c5fce71a43af77e5b37107d9ea'
AND (
token = 'ns5VuqIhG0ioKwlFABE58Yfn5nwoMC3T5jKr8fFPQMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)