UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZVc/jfRYB7q449ULRwZTNaGr8O8A9jxwXW2b6+6Jryw='
WHERE
key_id = '34424a3cbf80e41b95b173b78ade0de62c39147f555d44adccfda77170745f40'
AND (
token = 'ZVc/jfRYB7q449ULRwZTNaGr8O8A9jxwXW2b6+6Jryw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)