UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gnLvMBG4oUCQS+hoREPhboGez7HtDtARTbQwgdb4BIM='
WHERE
key_id = 'a82d566d12c0bd5060dd77b0abd8059a1952e0fb707e5b79a3425b5273bf78eb'
AND (
token = 'gnLvMBG4oUCQS+hoREPhboGez7HtDtARTbQwgdb4BIM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)