UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6poY0GHAcrNUW7DV5AhyZcWCtsCSTQRHBaJU1OFg3AY='
WHERE
key_id = '5527577b446555cf5a832460e2e2ea951b2cb32d4811fd1eb5605d29e83e70df'
AND (
token = '6poY0GHAcrNUW7DV5AhyZcWCtsCSTQRHBaJU1OFg3AY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)