UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A9wx5ghF/LpWA88U4LhmJ9BDcVUmltxxgB8iej5LJEg='
WHERE
key_id = '11c22a4f1d2902d201ed2c2e3b870975fe55cbc70e223d146d6e284cd107b9fc'
AND (
token = 'A9wx5ghF/LpWA88U4LhmJ9BDcVUmltxxgB8iej5LJEg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)