UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Pb3t3CYA8gC7ac+fOfeUApE6w4gSecd/9eX9f1AAS0='
WHERE
key_id = '3214335118b248700e768f8ea5cbc84597b51a470b33ea5b5d13efd73ac60dde'
AND (
token = '0Pb3t3CYA8gC7ac+fOfeUApE6w4gSecd/9eX9f1AAS0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)