UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zn9eMKGIqh8b8ddwkI6oGfLRd0JKSXmQF3cfFoNF6X0='
WHERE
key_id = '39012efe3fa26073767dd94b0c290fcfab742906293bfaa7f3542ab6705729a6'
AND (
token = 'zn9eMKGIqh8b8ddwkI6oGfLRd0JKSXmQF3cfFoNF6X0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)