UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pLZnwPJTZsIE8gbnuAwWA4EweOHM26qpEizjmKrq/w8='
WHERE
key_id = '71263a22054096e9e2f7b87ebd4325e3db5296cd41ff6c357400c14a74f0764a'
AND (
token = 'pLZnwPJTZsIE8gbnuAwWA4EweOHM26qpEizjmKrq/w8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)